<%@page import="com.xbk.jtable.ui.jForm"%>
<%@page import="com.xbk.jtable.ui.jTableUtil"%>
<%@page import="com.xbk.platform.DataMap"%>
<%@page import="com.xbk.util.StringUtil"%>
<%@page import="com.xbk.jtable.ui.Widget"%>
<%@page import="com.xbk.jtable.ui.jTable"%>
<%@page import="com.xbk.platform.DaoUtil"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<%@include file="/Include/include.jspf"%>
<style type="text/css">
</style>
<%
	DaoUtil du = ConnectionMananger.getDaoUtil();
	String sTableName = request.getParameter("TableName");
	
	String jtableData = "";
	DataMap inter = new DataMap(); 
	
	String sSql = "SELECT INPUTDATE,SERINO,ORG,CONTRACTNO,CUSTID,REPAYDATE,MATURITY,SUBJECT,CLASS,BALANCE "+
			"FROM CLASS5 WHERE INPUTDATE = '2012/03/31'";
	jTable jtable = new jTable(du);
	jtable.setRelativeTable("CLASS5");
	jtable.setKeyCols("INPUTDATE,SERINO,CONTRACTNO");
	jtable.setPageSize(20);
	jtable.initBySql(sSql);
	jtable.setHeader(du.getCols(sSql));
	jtableData = jtable.getHtml();
	jtable.setSession(session);
	du.close();
%>
</head>
<body>
<!-- content -->
  	<div id="jtableContainer" class="mg20 mt100 mb0"></div>
</body>
<script type="text/javascript">
$(function() {
	$(function(){
		var jtable = new jDcp.web.Table();
		jtable.parse("<%=jtableData %>");
		jtable.appendTo("jtableContainer");
	});
});
</script>
</html>